Making changes to the endpoint connection information

In the "endpoints" section, you can make changes to the connection string and the password. The following is an example of the "endpoints" section of the *.json file.

"endpoints": [{

"name": "Oracle_Source",

"type": "Oracle",

"connection_string": "server= bee01-xp:1521/xe;username=SYSTEM",

"authenticator": "{01000000D08C9DDF0115D1118C7A00C04FC297EB010000003EA495B32CAAE14CB9777B96B3CC00B30000000002000000000003660000A8000000100000002765A3287AB56447DA31508F71CE62700000000004800000A00000001000000088D5C1BBD615BEEEAF5FAC1B9B0E20800800000075D89177A9C6F11B1400000047B3110B80920DD9EB0A5FABA05679979B78DDD0}",

"role": "SOURCE"

}, {

"name": "SQLSERVER_Target",

"type": "SQLServer",

"connection_string": "server=bee01-xp;endpoint=tempdb;WindowsAuthentication=Y;CDCBCP=Y;FullloadBCP=Y;BCPPacketSize=16384",

"role": "TARGET"

To change the connect string:

1. In the *.json file, under "endpoints", find "connection string".

   For example, "connection_string": "server= bee01:1521/xe;username=SYSTEM".

2. Change the information after the equal signs (=) as necessary.

   For example, if the endpoint in the new environment is on a computer called B2, change server=bee01 to server=B2.

   Warning note

   Make sure that the connect string remains between the quotation marks (").

To change an endpoint password:

1. In the *.json file, under "endpoints", find "authenticator".

   For example, "authenticator": "{01000000D08C9DDF0115D1118C7A00C04FC297EB010000003EA495B32CAAE14CB9777B96B3CC00B30000000002000000000003660000A8000000100000002765A3287AB56447DA31508F71CE62700000000004800000A00000001000000088D5C1BBD615BEEEAF5FAC1B9B0E20800800000075D89177A9C6F11B1400000047B3110B80920DD9EB0A5FABA05679979B78DDD0}".

   Information note

   The password is presented as an encrypted string.

2. Change the password string to the relevant password for the endpoint in the new environment. Type the new password using plain text exactly as it is configured in the endpoint. For example, 8yTkLMt.

   When you save the file and then import it to the new environment, the password is encrypted automatically.